package com.cvic.se.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.cvic.se.entity.Department;

/**
 * <p>
 * InnoDB free: 4096 kB; (`INST_ID`) REFER `work1/institution`(`INST_ID`) Mapper 接口
 * </p>
 *
 * @author zgx
 * @since 2021-07-21
 */
public interface DepartmentMapper extends BaseMapper<Department> {
    
	@Select("select * from department where INST_ID=#{id}")
	public List<Department> getAll(@Param("id") String id);
	
	
	@Delete("delete from department where DEPT_ID = #{deptId}")
	public int deleteDept(@Param("deptId") Integer id);

	public int insertDept(@Param("dept") Department dept);
	
	public int updateDept(@Param("dept") Department dept);
}
